IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[DeleteCocina]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[DeleteCocina]
GO

CREATE PROCEDURE [dbo].[DeleteCocina]
(
	@cocinaID int
)
AS
BEGIN
	SET NOCOUNT ON

	UPDATE [Cocina] SET [estado] = 'A' WHERE [cocinaID] = @cocinaID

	SET NOCOUNT OFF
END

GO
